﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="AdsDataComponent" targetNamespace="uri:AspNet:StarterKits:TradingCenter:Data" xmlns:mstns="uri:AspNet:StarterKits:TradingCenter:Data" xmlns="uri:AspNet:StarterKits:TradingCenter:Data" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
	<xs:annotation>
		<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
			<DataSource DefaultConnectionIndex="1" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
				<Connections>
					<Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="TradingCenterConnection" IsAppSettingsProperty="true" Modifier="Assembly" Name="TradingCenterConnection (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.TradingCenterConnection.ConnectionString" Provider="System.Data.SqlClient" />
					<Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="TradingCenterConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="TradingCenterConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.SpiderMaster.AspNet.TradingSystem.Properties.Settings.0.Default.TradingCenterConnectionString" Provider="System.Data.SqlClient" />
				</Connections>
				<Tables>
					<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AdsDataAdapter" GeneratorDataComponentClassName="AdsDataAdapter" Name="Ads" UserDataComponentName="AdsDataAdapter">
						<MainSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetAdById" GetMethodModifier="Public" GetMethodName="GetAdById" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetAdById" UserSourceName="GetAdById">
								<DeleteCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>RemoveAd</CommandText>
										<Parameters>
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</DeleteCommand>
								<InsertCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>InsertAd</CommandText>
										<Parameters>
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="MemberId" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="CategoryId" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" ProviderType="Money" Scale="4" Size="8" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpirationDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="ExpirationDate" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="DateCreated" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateApproved" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumn="DateApproved" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumViews" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="NumViews" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumResponses" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="NumResponses" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="AdLevel" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="AdStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdType" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="AdType" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</InsertCommand>
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>GetAdById</CommandText>
										<Parameters>
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
								<UpdateCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>UpdateAd</CommandText>
										<Parameters>
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumn="MemberId" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumn="Title" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumn="Description" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumn="URL" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" ProviderType="Money" Scale="4" Size="8" SourceColumn="Price" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Location" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</UpdateCommand>
							</DbSource>
						</MainSource>
						<Mappings>
							<Mapping SourceColumn="Id" DataSetColumn="Id" />
							<Mapping SourceColumn="MemberId" DataSetColumn="MemberId" />
							<Mapping SourceColumn="CategoryId" DataSetColumn="CategoryId" />
							<Mapping SourceColumn="Title" DataSetColumn="Title" />
							<Mapping SourceColumn="Description" DataSetColumn="Description" />
							<Mapping SourceColumn="URL" DataSetColumn="URL" />
							<Mapping SourceColumn="Price" DataSetColumn="Price" />
							<Mapping SourceColumn="Location" DataSetColumn="Location" />
							<Mapping SourceColumn="ExpirationDate" DataSetColumn="ExpirationDate" />
							<Mapping SourceColumn="DateCreated" DataSetColumn="DateCreated" />
							<Mapping SourceColumn="DateApproved" DataSetColumn="DateApproved" />
							<Mapping SourceColumn="NumViews" DataSetColumn="NumViews" />
							<Mapping SourceColumn="NumResponses" DataSetColumn="NumResponses" />
							<Mapping SourceColumn="AdLevel" DataSetColumn="AdLevel" />
							<Mapping SourceColumn="AdStatus" DataSetColumn="AdStatus" />
							<Mapping SourceColumn="AdType" DataSetColumn="AdType" />
							<Mapping SourceColumn="PreviewImageId" DataSetColumn="PreviewImageId" />
							<Mapping SourceColumn="MemberName" DataSetColumn="MemberName" />
							<Mapping SourceColumn="CategoryName" DataSetColumn="CategoryName" />
						</Mappings>
						<Sources>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="ExpireAd" Modifier="Public" Name="ExpireAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="ExpireAd">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>ExpireAd</CommandText>
										<Parameters>
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetAdsByRandomOrder" GetMethodModifier="Public" GetMethodName="GetAdsByRandomOrder" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAdsByRandomOrder" UserSourceName="GetAdsByRandomOrder">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>GetAdsByRandomOrder</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumRecords" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetAdsByStatus" GetMethodModifier="Public" GetMethodName="GetAdsByStatus" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAdsByStatus" UserSourceName="GetAdsByStatus">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>GetAdsByStatus</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetAllAdsByQuery" GetMethodModifier="Public" GetMethodName="GetAllAdsByQuery" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetAllAdsByQuery" UserSourceName="GetAllAdsByQuery">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>GetAllAdsByQuery</CommandText>
										<Parameters>
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LimitResultCount" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@MaxPrice" Precision="18" ProviderType="Decimal" Scale="0" Size="9" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SearchTerm" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdType" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@MinDateCreated" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@MustHaveImage" Precision="1" ProviderType="Bit" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetExpiredAds" GetMethodModifier="Public" GetMethodName="GetExpiredAds" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetExpiredAds" UserSourceName="GetExpiredAds">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>GetExpiredAds</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpirationDate" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetSavedAds" GetMethodModifier="Public" GetMethodName="GetSavedAds" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetSavedAds" UserSourceName="GetSavedAds">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>GetSavedAds</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertAd" Modifier="Public" Name="InsertAd" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertAd">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="true">
										<CommandText>InsertAd</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" Scale="0" Size="2500" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" Scale="4" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpirationDate" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateApproved" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumViews" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumResponses" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdType" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertSavedAd" Modifier="Public" Name="InsertSavedAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="InsertSavedAd">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>InsertSavedAd</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="MoveAds" Modifier="Public" Name="MoveAds" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="MoveAds">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>MoveAds</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CurrentCategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NewCategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="RelistAd" Modifier="Public" Name="RelistAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="RelistAd">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>RelistAd</CommandText>
										<Parameters>
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" ProviderType="NText" Scale="0" Size="1073741823" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" ProviderType="NVarChar" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" ProviderType="Money" Scale="4" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" ProviderType="NVarChar" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@ExpirationDate" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateApproved" Precision="16" ProviderType="SmallDateTime" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdType" Precision="10" ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="RemoveAd" Modifier="Public" Name="RemoveAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy5" UserSourceName="RemoveAd">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>RemoveAd</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="RemoveAdsByStatus" Modifier="Public" Name="RemoveAdsByStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy6" UserSourceName="RemoveAdsByStatus">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>RemoveAdsByStatus</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="RemoveSavedAd" Modifier="Public" Name="RemoveSavedAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy7" UserSourceName="RemoveSavedAd">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>RemoveSavedAd</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateAd" Modifier="Public" Name="UpdateAd" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy8" UserSourceName="UpdateAd">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="true">
										<CommandText>UpdateAd</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MemberId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" Scale="0" Size="100" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Description" Precision="0" Scale="0" Size="2500" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@URL" Precision="0" Scale="0" Size="500" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="@Price" Precision="19" Scale="4" Size="8" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Location" Precision="0" Scale="0" Size="50" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateAdCategory" Modifier="Public" Name="UpdateAdCategory" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy9" UserSourceName="UpdateAdCategory">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>UpdateAdCategory</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateAdLevel" Modifier="Public" Name="UpdateAdLevel" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy10" UserSourceName="UpdateAdLevel">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>UpdateAdLevel</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdLevel" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateAdStats" Modifier="Public" Name="UpdateAdStats" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy11" UserSourceName="UpdateAdStats">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>UpdateAdStats</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberToAddToViews" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberToAddToResponses" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UpdateAdStatus" Modifier="Public" Name="UpdateAdStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy12" UserSourceName="UpdateAdStatus">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>UpdateAdStatus</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
						</Sources>
					</TableAdapter>
					<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PhotosDataAdapter" GeneratorDataComponentClassName="PhotosDataAdapter" Name="Photos" UserDataComponentName="PhotosDataAdapter">
						<MainSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="[V:\SOURCE\APPLICATION\SpiderMaster.AspNet.TradingSystem.WEBAPPLICATION\APP_DATA\TradingCenterDB.MDF].dbo.GetPhotosByAdId" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetPhotosByAdId" GetMethodModifier="Public" GetMethodName="GetPhotosByAdId" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetPhotosByAdId" UserSourceName="GetPhotosByAdId">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>GetPhotosByAdId</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
						</MainSource>
						<Mappings>
							<Mapping SourceColumn="Id" DataSetColumn="Id" />
							<Mapping SourceColumn="AdId" DataSetColumn="AdId" />
							<Mapping SourceColumn="IsMainPreview" DataSetColumn="IsMainPreview" />
							<Mapping SourceColumn="DateCreated" DataSetColumn="DateCreated" />
						</Mappings>
						<Sources>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="[V:\SOURCE\APPLICATION\SpiderMaster.AspNet.TradingSystem.WEBAPPLICATION\APP_DATA\TradingCenterDB.MDF].dbo.GetPhotoBytesById" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="GetPhotoBytesById" Modifier="Public" Name="GetPhotoBytesById" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetPhotoBytesById">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>GetPhotoBytesById</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Size" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="[V:\SOURCE\APPLICATION\SpiderMaster.AspNet.TradingSystem.WEBAPPLICATION\APP_DATA\TradingCenterDB.MDF].dbo.GetPhotosByAdStatus" DbObjectType="StoredProcedure" GenerateMethods="Get" GenerateShortCommands="true" GeneratorGetMethodName="GetPhotosByAdStatus" GetMethodModifier="Public" GetMethodName="GetPhotosByAdStatus" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetPhotosByAdStatus" UserSourceName="GetPhotosByAdStatus">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>GetPhotosByAdStatus</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="[V:\SOURCE\APPLICATION\SpiderMaster.AspNet.TradingSystem.WEBAPPLICATION\APP_DATA\TradingCenterDB.MDF].dbo.InsertPhoto" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="InsertPhoto" Modifier="Public" Name="InsertPhoto" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="InsertPhoto">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="true">
										<CommandText>InsertPhoto</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BytesFull" Precision="0" Scale="0" Size="0" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BytesMedium" Precision="0" Scale="0" Size="0" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@BytesSmall" Precision="0" Scale="0" Size="0" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@IsMainPreview" Precision="1" Scale="0" Size="1" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateCreated" Precision="16" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="[V:\SOURCE\APPLICATION\SpiderMaster.AspNet.TradingSystem.WEBAPPLICATION\APP_DATA\TradingCenterDB.MDF].dbo.RemovePhoto" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="RemovePhoto" Modifier="Public" Name="RemovePhoto" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy2" UserSourceName="RemovePhoto">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>RemovePhoto</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="[V:\SOURCE\APPLICATION\SpiderMaster.AspNet.TradingSystem.WEBAPPLICATION\APP_DATA\TradingCenterDB.MDF].dbo.RemovePhotosByAdStatus" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="RemovePhotosByAdStatus" Modifier="Public" Name="RemovePhotosByAdStatus" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy3" UserSourceName="RemovePhotosByAdStatus">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>RemovePhotosByAdStatus</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdStatus" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
							<DbSource ConnectionRef="TradingCenterConnectionString (Settings)" DbObjectName="[V:\SOURCE\APPLICATION\SpiderMaster.AspNet.TradingSystem.WEBAPPLICATION\APP_DATA\TradingCenterDB.MDF].dbo.SetAdPreviewPhoto" DbObjectType="StoredProcedure" GenerateShortCommands="true" GeneratorSourceName="SetAdPreviewPhoto" Modifier="Public" Name="SetAdPreviewPhoto" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy4" UserSourceName="SetAdPreviewPhoto">
								<SelectCommand>
									<DbCommand CommandType="StoredProcedure" ModifiedByUser="false">
										<CommandText>SetAdPreviewPhoto</CommandText>
										<Parameters>
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PhotoId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
											<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@AdId" Precision="10" Scale="0" Size="4" SourceColumnNullMapping="false" SourceVersion="Current" />
										</Parameters>
									</DbCommand>
								</SelectCommand>
							</DbSource>
						</Sources>
					</TableAdapter>
				</Tables>
				<Sources />
			</DataSource>
		</xs:appinfo>
	</xs:annotation>
	<xs:element name="AdsDataComponent" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_DataSetName="AdsDataComponent" msprop:Generator_UserDSName="AdsDataComponent">
		<xs:complexType>
			<xs:choice minOccurs="0" maxOccurs="unbounded">
				<xs:element name="Ads" msprop:Generator_TableClassName="AdsDataTable" msprop:Generator_TableVarName="tableAds" msprop:Generator_TablePropName="Ads" msprop:Generator_RowDeletingName="AdsRowDeleting" msprop:Generator_UserTableName="Ads" msprop:Generator_RowChangingName="AdsRowChanging" msprop:Generator_RowEvHandlerName="AdsRowChangeEventHandler" msprop:Generator_RowDeletedName="AdsRowDeleted" msprop:Generator_RowEvArgName="AdsRowChangeEvent" msprop:Generator_RowChangedName="AdsRowChanged" msprop:Generator_RowClassName="AdsRow">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
							<xs:element name="MemberId" msprop:Generator_ColumnVarNameInTable="columnMemberId" msprop:Generator_ColumnPropNameInRow="MemberId" msprop:Generator_ColumnPropNameInTable="MemberIdColumn" msprop:Generator_UserColumnName="MemberId" type="xs:int" />
							<xs:element name="CategoryId" msprop:Generator_ColumnVarNameInTable="columnCategoryId" msprop:Generator_ColumnPropNameInRow="CategoryId" msprop:Generator_ColumnPropNameInTable="CategoryIdColumn" msprop:Generator_UserColumnName="CategoryId" type="xs:int" />
							<xs:element name="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" msprop:Generator_UserColumnName="Title">
								<xs:simpleType>
									<xs:restriction base="xs:string">
										<xs:maxLength value="100" />
									</xs:restriction>
								</xs:simpleType>
							</xs:element>
							<xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description">
								<xs:simpleType>
									<xs:restriction base="xs:string">
										<xs:maxLength value="1073741823" />
									</xs:restriction>
								</xs:simpleType>
							</xs:element>
							<xs:element name="URL" msprop:Generator_ColumnVarNameInTable="columnURL" msprop:Generator_ColumnPropNameInRow="URL" msprop:Generator_ColumnPropNameInTable="URLColumn" msprop:Generator_UserColumnName="URL">
								<xs:simpleType>
									<xs:restriction base="xs:string">
										<xs:maxLength value="500" />
									</xs:restriction>
								</xs:simpleType>
							</xs:element>
							<xs:element name="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnPropNameInTable="PriceColumn" msprop:Generator_UserColumnName="Price" type="xs:decimal" />
							<xs:element name="Location" msprop:Generator_ColumnVarNameInTable="columnLocation" msprop:Generator_ColumnPropNameInRow="Location" msprop:Generator_ColumnPropNameInTable="LocationColumn" msprop:Generator_UserColumnName="Location">
								<xs:simpleType>
									<xs:restriction base="xs:string">
										<xs:maxLength value="50" />
									</xs:restriction>
								</xs:simpleType>
							</xs:element>
							<xs:element name="ExpirationDate" msprop:Generator_ColumnVarNameInTable="columnExpirationDate" msprop:Generator_ColumnPropNameInRow="ExpirationDate" msprop:Generator_ColumnPropNameInTable="ExpirationDateColumn" msprop:Generator_UserColumnName="ExpirationDate" type="xs:dateTime" minOccurs="0" />
							<xs:element name="DateCreated" msprop:Generator_ColumnVarNameInTable="columnDateCreated" msprop:Generator_ColumnPropNameInRow="DateCreated" msprop:Generator_ColumnPropNameInTable="DateCreatedColumn" msprop:Generator_UserColumnName="DateCreated" type="xs:dateTime" />
							<xs:element name="DateApproved" msprop:Generator_ColumnVarNameInTable="columnDateApproved" msprop:Generator_ColumnPropNameInRow="DateApproved" msprop:Generator_ColumnPropNameInTable="DateApprovedColumn" msprop:Generator_UserColumnName="DateApproved" type="xs:dateTime" minOccurs="0" />
							<xs:element name="NumViews" msprop:Generator_ColumnVarNameInTable="columnNumViews" msprop:Generator_ColumnPropNameInRow="NumViews" msprop:Generator_ColumnPropNameInTable="NumViewsColumn" msprop:Generator_UserColumnName="NumViews" type="xs:int" />
							<xs:element name="NumResponses" msprop:Generator_ColumnVarNameInTable="columnNumResponses" msprop:Generator_ColumnPropNameInRow="NumResponses" msprop:Generator_ColumnPropNameInTable="NumResponsesColumn" msprop:Generator_UserColumnName="NumResponses" type="xs:int" />
							<xs:element name="AdLevel" msprop:Generator_ColumnVarNameInTable="columnAdLevel" msprop:Generator_ColumnPropNameInRow="AdLevel" msprop:Generator_ColumnPropNameInTable="AdLevelColumn" msprop:Generator_UserColumnName="AdLevel" type="xs:int" />
							<xs:element name="AdStatus" msprop:Generator_ColumnVarNameInTable="columnAdStatus" msprop:Generator_ColumnPropNameInRow="AdStatus" msprop:Generator_ColumnPropNameInTable="AdStatusColumn" msprop:Generator_UserColumnName="AdStatus" type="xs:int" />
							<xs:element name="AdType" msprop:Generator_ColumnVarNameInTable="columnAdType" msprop:Generator_ColumnPropNameInRow="AdType" msprop:Generator_ColumnPropNameInTable="AdTypeColumn" msprop:Generator_UserColumnName="AdType" type="xs:int" />
							<xs:element name="PreviewImageId" msprop:Generator_ColumnVarNameInTable="columnPreviewImageId" msprop:Generator_ColumnPropNameInRow="PreviewImageId" msprop:Generator_ColumnPropNameInTable="PreviewImageIdColumn" msprop:Generator_UserColumnName="PreviewImageId" type="xs:int" minOccurs="0" />
							<xs:element name="MemberName" msprop:Generator_ColumnVarNameInTable="columnMemberName" msprop:Generator_ColumnPropNameInRow="MemberName" msprop:Generator_ColumnPropNameInTable="MemberNameColumn" msprop:Generator_UserColumnName="MemberName">
								<xs:simpleType>
									<xs:restriction base="xs:string">
										<xs:maxLength value="256" />
									</xs:restriction>
								</xs:simpleType>
							</xs:element>
							<xs:element name="CategoryName" msprop:Generator_ColumnVarNameInTable="columnCategoryName" msprop:Generator_ColumnPropNameInRow="CategoryName" msprop:Generator_ColumnPropNameInTable="CategoryNameColumn" msprop:Generator_UserColumnName="CategoryName">
								<xs:simpleType>
									<xs:restriction base="xs:string">
										<xs:maxLength value="50" />
									</xs:restriction>
								</xs:simpleType>
							</xs:element>
						</xs:sequence>
					</xs:complexType>
				</xs:element>
				<xs:element name="Photos" msprop:Generator_TableClassName="PhotosDataTable" msprop:Generator_TableVarName="tablePhotos" msprop:Generator_TablePropName="Photos" msprop:Generator_RowDeletingName="PhotosRowDeleting" msprop:Generator_UserTableName="Photos" msprop:Generator_RowChangingName="PhotosRowChanging" msprop:Generator_RowEvHandlerName="PhotosRowChangeEventHandler" msprop:Generator_RowDeletedName="PhotosRowDeleted" msprop:Generator_RowEvArgName="PhotosRowChangeEvent" msprop:Generator_RowChangedName="PhotosRowChanged" msprop:Generator_RowClassName="PhotosRow">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" msprop:Generator_UserColumnName="Id" type="xs:int" />
							<xs:element name="AdId" msprop:Generator_ColumnVarNameInTable="columnAdId" msprop:Generator_ColumnPropNameInRow="AdId" msprop:Generator_ColumnPropNameInTable="AdIdColumn" msprop:Generator_UserColumnName="AdId" type="xs:int" />
							<xs:element name="IsMainPreview" msprop:Generator_ColumnVarNameInTable="columnIsMainPreview" msprop:Generator_ColumnPropNameInRow="IsMainPreview" msprop:Generator_ColumnPropNameInTable="IsMainPreviewColumn" msprop:Generator_UserColumnName="IsMainPreview" type="xs:boolean" />
							<xs:element name="DateCreated" msprop:Generator_ColumnVarNameInTable="columnDateCreated" msprop:Generator_ColumnPropNameInRow="DateCreated" msprop:Generator_ColumnPropNameInTable="DateCreatedColumn" msprop:Generator_UserColumnName="DateCreated" type="xs:dateTime" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:choice>
		</xs:complexType>
		<xs:unique name="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Ads" />
			<xs:field xpath="mstns:Id" />
		</xs:unique>
		<xs:unique name="Photos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
			<xs:selector xpath=".//mstns:Photos" />
			<xs:field xpath="mstns:Id" />
		</xs:unique>
	</xs:element>
</xs:schema>